home *** CD-ROM | disk | FTP | other *** search
/ MacWorld 2003 May (DVD) / Macworld Resource DVD May 2003.toast / Data / Software / Bonus / Database / mysql-max-3.23.55.sit / mysql-max-3.23.55-apple-darwi.1 / mysql-test / t / func_misc.test < prev    next >
Encoding:
Text File  |  2003-01-21  |  410 b   |  10 lines  |  [TEXT/ttxt]
  1. #
  2. # Testing of misc functions
  3. #
  4.  
  5. select format(1.5555,0),format(123.5555,1),format(1234.5555,2),format(12345.5555,3),format(123456.5555,4),format(1234567.5555,5),format("12345.2399",2);
  6.  
  7. select inet_ntoa(inet_aton("255.255.255.255.255.255.255.255"));
  8. select inet_aton("255.255.255.255.255"),inet_aton("255.255.1.255"),inet_aton("0.1.255");
  9. select inet_ntoa(1099511627775),inet_ntoa(4294902271),inet_ntoa(511);
  10.